The reference SQL Server Spatial database files can be used with the reference SQL Server Spatial workspace. SQL Server Management Studio is used to attach the database and enable user access to the database.

To attach the spatial database files :

1. Navigate to the reference SQL Server spatial database files. The files are typically expanded to the "BentleyDownloads\bud08110909xx" folder.
   
2. Copy the files BUDV8iSpatial.mdf and BUDV8iSpatial.ldf to the SQL Server Data folder. The path varies depending on the specific SQL Server installed.
   
3. Start SQL Server Management Studio log in with administrator privileges.
4. Right-Click on Databases and select "Attach…" from the popup menu. The Attach Databases dialog appears.
   
5. Click the Add button to invoke the Locate Database Files dialog.
   
6. Select the BUDV8iSpatial.mdf file and click the OK button in the Locate Database Files dialog.
7. Click the OK button in the Attach Databases dialog.
   
8. Right-Click on the BUDV8iSpatial database entry and select Properties in the popup menu. The Database Properties dialog opens.
   
9. Select the Files entry in the Select a page view.
   
10. Click the "…" button in the Database Properties dialog to open the Select a Database Owner dialog.
11. Enter an owner for the database with administrator priviligies and click the Check Names button. If it is successful the button dims. If it was not successful, try again.
    
12. Click the OK button to accept the entry and dismiss the Select Database Owner dialog.
13. Click the OK button in the Database Properties dialog to accept the change.
    

To add a new user login :

1. Start SQL Server Management Studio log in with administrator privileges.
2. Open the Security entry.
3. Right-Click on Logins and select New Login… in the popup menu. The Login - New dialog opens.
   
4. Click the Search button in the General page of the Login - New dialog to open the Select User or Group dialog.
   
5. Enter a user name and click the Check Names button in the Select User or Group dialog to return to the Login - New dialog.
   
6. Click the OK button to accept the user and return to the Login - New dialog.
7. Select the User Mapping page in the Login - New dialog.
8. Map Users to databases are required.
   
9. Click the OK button to complete the new login.